More than 10 years of experience in SSIS, SSRS, SSAS, MDM, Data Warehousing, Business Intelligence as a MSBI Consultant, Application Integration using BizTalk and Designing & Developing Enterprise Applications using ASP.Net WebForms/MVC. I have been involved in multiple Business Intelligence projects as DWH & ETL Designer/Developer, MDS Developer and SSIS/SSRS Consultant. I have working knowledge of MS Power BI and Tableau.I am striving to obtain a career position that will make use of my skills, leadership, experience and problem-solving abilities with an organization that expects and rewards superior performance.
Skills:
• Expertise in Gathering Business Requirements and Analysis.
• Translating the Requirements into High level Architecture Design, Low level design documents, producing artifacts such as Requirement Specification document, Logical Data Model, Physical Data Model, DFD and Context Diagrams, DDL Scripts, Source to Target Mapping Document.
• Good Data Modeling Skills (OLTP, OLAP) , Use Case Diagrams, Entity Relationship Modeling, Star Schema, Snowflake Schema, using ER Studio, ERWIN and Rational Rose.
• Design, Develop and Maintain SSIS Packages and Scheduling them using Sql Server Agent.
• MDS (Master Data Services) for Master Data Management while developing SSIS Packages.
• Design Develop T-SQL Stored Procedures.
• Develop Powershell Scripts.
• Worked on the ETL Design to load data from Source to ODS to DWH. Working knowledge of techniques like CDC, SCD Type 1 & 2, Partitioning etc.
Projects:
Revlon MDM/MDF/BI:
Working for REVLON US on Data Migration & Integration Project using SSIS, SSRS, Power BI, MDS (Master Data Services) . This involves retrieving data from Systems like Oracle Financials, BPCS (DB2), GEMMS (Oracle), loading it into Microsoft Dynamics AX 2012 and Master Data Management. Now loading data into SAP.
Used SAP.net connector to call Functions/BAPIs in exposed from SAP to retrieve and load data into SA
Revlon MDM/MDF/BI:
Working for REVLON US on Data Migration & Integration Project using SSIS, SSRS, Power BI, MDS (Master Data Services) . This involves retrieving data from Systems like Oracle Financials, BPCS (DB2), GEMMS (Oracle), loading it into Microsoft Dynamics AX 2012 and Master Data Management. Now loading data into SAP.
Used SAP.net connector to call Functions/BAPIs in exposed from SAP to retrieve and load data into SAP.
System Analyst & Database Development
BI& ETL Develpor